home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Sun Solutions 2000 #2
/
Sun Solutions CD (Volume 2 2000)(Special Focus - Java Technologies)(Disc 1).ISO
/
products
/
Software
/
PlanetIntra
/
_install
/
conf
/
pidb
< prev
Wrap
Text File
|
2000-02-17
|
19KB
|
579 lines
# MySQL dump 6.0
#
# Host: localhost Database: pi_dumdum
#--------------------------------------------------------
# Server version 3.22.26a
#
# Table structure for table 'CALENDAR'
#
CREATE TABLE CALENDAR (
Calendar_Id int(11) DEFAULT '0' NOT NULL,
Calendar_Name varchar(255),
Employee_Id int(11),
User_Group_Id int(11),
Department_Id int(11),
PRIMARY KEY (Calendar_Id)
);
#
# Dumping data for table 'CALENDAR'
#
#
# Table structure for table 'CALENDAR_MEMBERSHIP'
#
CREATE TABLE CALENDAR_MEMBERSHIP (
Calendar_Id int(11) DEFAULT '0' NOT NULL,
Employee_Id int(11) DEFAULT '0' NOT NULL,
Cal_Read int(11),
Cal_Post int(11),
Cal_Modify int(11),
Is_Calendar_Administrator int(11),
PRIMARY KEY (Calendar_Id)
);
#
# Dumping data for table 'CALENDAR_MEMBERSHIP'
#
#
# Table structure for table 'DEPARTMENT'
#
CREATE TABLE DEPARTMENT (
Department_Id int(11) DEFAULT '0' NOT NULL,
Department_Name varchar(32) DEFAULT 'No Name',
Object_Id int(11) DEFAULT '0',
PRIMARY KEY (Department_Id)
);
#
# Dumping data for table 'DEPARTMENT'
#
INSERT INTO DEPARTMENT VALUES (2,'Marketing',6);
INSERT INTO DEPARTMENT VALUES (3,'Human Resources',4);
INSERT INTO DEPARTMENT VALUES (8,'Office Information',15);
INSERT INTO DEPARTMENT VALUES (6,'Sales',13);
INSERT INTO DEPARTMENT VALUES (101,'Help Center',101);
#
# Table structure for table 'DEPARTMENT_MEMBERSHIP'
#
CREATE TABLE DEPARTMENT_MEMBERSHIP (
Employee_Id int(11) DEFAULT '0' NOT NULL,
Department_Id int(11) DEFAULT '0' NOT NULL,
Is_Department_Administrator int(11) DEFAULT '1',
PRIMARY KEY (Employee_Id,Department_Id)
);
#
# Dumping data for table 'DEPARTMENT_MEMBERSHIP'
#
#
# Table structure for table 'DOCUMENT'
#
CREATE TABLE DOCUMENT (
Object_Id int(11) DEFAULT '0' NOT NULL,
Time_Created int(11),
Time_Modified int(11) DEFAULT '0',
Document_RegNo int(11) DEFAULT '0',
User_Group_Id int(11) DEFAULT '0',
Content_Type char(64) DEFAULT '' NOT NULL,
PRIMARY KEY (Object_Id)
);
#
# Dumping data for table 'DOCUMENT'
#
INSERT INTO DOCUMENT VALUES (3,935686293,947784130,6,0,'text/html');
INSERT INTO DOCUMENT VALUES (4,936041637,942449411,14,-3,'text/html');
INSERT INTO DOCUMENT VALUES (5,936042717,936116382,9,102,'text/html');
INSERT INTO DOCUMENT VALUES (6,936045221,942449869,4,-2,'text/html');
INSERT INTO DOCUMENT VALUES (110,945985267,945985267,26,101,'text/html');
INSERT INTO DOCUMENT VALUES (13,936109224,945878712,10,-6,'text/html');
INSERT INTO DOCUMENT VALUES (15,936123944,942452072,11,-8,'text/html');
INSERT INTO DOCUMENT VALUES (101,942257491,942448649,16,-101,'text/html');
INSERT INTO DOCUMENT VALUES (102,942437103,942447043,18,101,'text/html');
INSERT INTO DOCUMENT VALUES (103,942446350,942446350,20,101,'text/html');
INSERT INTO DOCUMENT VALUES (105,942447977,945985033,29,101,'text/html');
INSERT INTO DOCUMENT VALUES (106,942448144,945985070,24,101,'text/html');
INSERT INTO DOCUMENT VALUES (107,942449070,942449070,28,101,'text/html');
INSERT INTO DOCUMENT VALUES (111,945985332,945986152,31,101,'text/html');
INSERT INTO DOCUMENT VALUES (112,945986405,945986405,33,101,'text/html');
#
# Table structure for table 'EMPLOYEE'
#
CREATE TABLE EMPLOYEE (
Employee_Id int(11) DEFAULT '0' NOT NULL,
Employee_First_Name varchar(20),
Employee_Middle_Name varchar(20) DEFAULT '',
Employee_Last_Name varchar(20) DEFAULT '',
Employee_Initials varchar(8) DEFAULT '',
Employee_Gender char(3) DEFAULT '',
Employee_Title varchar(32) DEFAULT '',
Employee_EMail varchar(32) DEFAULT '',
Employee_TelNo_1 varchar(25) DEFAULT '',
Employee_TelNo_2 varchar(25) DEFAULT '',
Employee_Pager varchar(32) DEFAULT '',
Employee_Mobile varchar(25) DEFAULT '',
Employee_FaxNo varchar(25) DEFAULT '',
Employee_Address varchar(64) DEFAULT '',
Employee_City varchar(20) DEFAULT '',
Employee_Province varchar(20) DEFAULT '',
Employee_Country varchar(20) DEFAULT '',
Employee_Postal_Code varchar(10) DEFAULT '',
Employee_Note varchar(128) DEFAULT '',
User_Name varchar(20) DEFAULT '',
User_Password varchar(16) DEFAULT '',
User_Defined_1 varchar(128) DEFAULT '',
User_Defined_2 varchar(128) DEFAULT '',
User_Defined_3 varchar(128) DEFAULT '',
User_Defined_4 varchar(128) DEFAULT '',
User_Defined_5 varchar(128) DEFAULT '',
Change_Data int(11) DEFAULT '0',
Is_Administrator int(11) DEFAULT '0',
Account_Locked int(11) DEFAULT '0',
Picture_Id int(11) DEFAULT '0',
Template_Style_Id int(11) DEFAULT '0',
Language_Id int(11) DEFAULT '1',
PRIMARY KEY (Employee_Id)
);
#
# Dumping data for table 'EMPLOYEE'
#
INSERT INTO EMPLOYEE VALUES (1,'System','','Administrator','X','M','Sys
Admin','','','','','','','','','','','','','admin','%s','full','','6','','',0,1,0,0,1,1);
INSERT INTO EMPLOYEE VALUES (101,'Karen','','Sales','','','','','','','','','','','','','','','','Karen','dummy','full','','','','',0,0,0,0,1,0);
INSERT INTO EMPLOYEE VALUES (102,'wtb','','Translation','','','','','','','','','','','','','','','','wtb','wtbwtb','full','','','','',0,1,0,0,1,1);
#
# Table structure for table 'EVENT'
#
CREATE TABLE EVENT (
Object_Id int(11) DEFAULT '0' NOT NULL,
Calendar_Id int(11),
Time_Modified int(11),
Time_Stamp int(11),
Duration varchar(255),
Time_Zone_Id int(11),
Year int(11),
Month int(11),
Day int(11),
Hour int(11),
Minute int(11),
Weekday int(11),
Reoccurring int(11),
Rule varchar(255),
Is_Done int(11),
Event_Type_Id int(11),
Event_Note varchar(255),
PRIMARY KEY (Object_Id)
);
#
# Dumping data for table 'EVENT'
#
#
# Table structure for table 'EVENT_TYPE'
#
CREATE TABLE EVENT_TYPE (
Event_Type_Id int(11) DEFAULT '0' NOT NULL,
Event_Name varchar(255),
Event_Icon varchar(255),
PRIMARY KEY (Event_Type_Id)
);
#
# Dumping data for table 'EVENT_TYPE'
#
INSERT INTO EVENT_TYPE VALUES (1,'Company Event','ico_company_event.gif');
INSERT INTO EVENT_TYPE VALUES (2,'General Event','ico_general_event.gif');
INSERT INTO EVENT_TYPE VALUES (3,'Company Meeting','ico_company_meeting.gif');
INSERT INTO EVENT_TYPE VALUES (4,'Project Status','ico_project_status.gif');
INSERT INTO EVENT_TYPE VALUES (5,'Phone concall','ico_concall.gif');
#
# Table structure for table 'FILE'
#
CREATE TABLE FILE (
Object_Id int(11) DEFAULT '0' NOT NULL,
Content_Type varchar(80),
Time_Uploaded int(11),
User_Group_Id int(11) DEFAULT '0',
Description_RegNo int(11) DEFAULT '0',
File_Name varchar(255) DEFAULT '',
PRIMARY KEY (Object_Id)
);
#
# Dumping data for table 'FILE'
#
INSERT INTO FILE VALUES (2,'image/gif',935858956,0,0,'Logo.gif');
INSERT INTO FILE VALUES (21,'image/gif',936129952,102,19,'Red Line.gif');
INSERT INTO FILE VALUES (19,'image/gif',936125819,102,18,'Salespage.gif');
INSERT INTO FILE VALUES (18,'image/gif',936125225,102,17,'Marketpage.gif');
INSERT INTO FILE VALUES (16,'image/gif',936125158,102,2,'HRpage.gif');
INSERT INTO FILE VALUES (17,'image/gif',936125183,102,15,'ITpage.gif');
INSERT INTO FILE VALUES (24,'image/gif',936131609,102,20,'Women.gif');
INSERT INTO FILE VALUES (25,'image/gif',936133026,102,21,'office info.gif');
INSERT INTO FILE VALUES (113,'image/gif',947783880,102,22,'picture.gif');
#
# Table structure for table 'JAddress_Info'
#
CREATE TABLE JAddress_Info (
IDNum int(11) DEFAULT '0' NOT NULL,
Country varchar(255),
State_Prov varchar(255),
Postal varchar(255),
City varchar(255),
Address varchar(50),
Individuals_Company int(11),
PRIMARY KEY (IDNum)
);
#
# Dumping data for table 'JAddress_Info'
#
#
# Table structure for table 'JComm_Info'
#
CREATE TABLE JComm_Info (
PIDNum int(11) DEFAULT '0' NOT NULL,
Phone varchar(255),
BPhone varchar(255),
Fax varchar(255),
Mobile_Phone varchar(255),
Email varchar(255),
Pager varchar(255),
ICQ varchar(255),
WebAddress varchar(255),
Phone2 varchar(255),
PRIMARY KEY (PIDNum)
);
#
# Dumping data for table 'JComm_Info'
#
#
# Table structure for table 'JNotes'
#
CREATE TABLE JNotes (
NIDNum int(11) DEFAULT '0' NOT NULL,
Event_Date int(11),
Record_Date int(11),
User_ID int(11),
Note_Body varchar(255),
Note_Title varchar(255),
NoteID int(11) DEFAULT '0' NOT NULL,
Event_Time int(11),
PRIMARY KEY (NoteID)
);
#
# Dumping data for table 'JNotes'
#
#
# Table structure for table 'JTitle_Info'
#
CREATE TABLE JTitle_Info (
IDNum int(11) DEFAULT '0' NOT NULL,
Type_Of_Entry varchar(255),
Last_Name varchar(255),
First_Name varchar(255),
Middle_Name varchar(255),
Company_Belong_To int(11),
Title varchar(255),
Birth_Date int(11),
Employee_ID int(11),
NatureOfContact varchar(255),
CompanyName varchar(255),
ReferenceOnly int(11),
PRIMARY KEY (IDNum)
);
#
# Dumping data for table 'JTitle_Info'
#
#
# Table structure for table 'LANGUAGE'
#
CREATE TABLE LANGUAGE (
Language_Id int(11) DEFAULT '0' NOT NULL,
Language_Name varchar(80),
Language_Code varchar(10),
Time_Format varchar(128),
Time_AM varchar(40),
Time_PM varchar(40),
Short_Date_Format varchar(128),
Long_Date_Format varchar(128),
Single_Name_Format varchar(128),
List_Name_Format varchar(128),
PRIMARY KEY (Language_Id)
);
#
# Dumping data for table 'LANGUAGE'
#
INSERT INTO LANGUAGE VALUES (1,'English','en','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
INSERT INTO LANGUAGE VALUES (2,'Serbian','sr','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
INSERT INTO LANGUAGE VALUES (3,'Chinese','zh','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
INSERT INTO LANGUAGE VALUES (4,'Croatian','sr','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
INSERT INTO LANGUAGE VALUES (5,'Serbian Cyr','sr-cyr','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
INSERT INTO LANGUAGE VALUES (6,'Chinese-Traditional','zh-tr','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
INSERT INTO LANGUAGE VALUES (7,'German','de','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
INSERT INTO LANGUAGE VALUES (8,'French','fr','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
INSERT INTO LANGUAGE VALUES (9,'Korean','ko','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
INSERT INTO LANGUAGE VALUES (10,'Russian','ru','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
INSERT INTO LANGUAGE VALUES (11,'Italian','it','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
INSERT INTO LANGUAGE VALUES (12,'Spanish','es','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
INSERT INTO LANGUAGE VALUES (13,'Portuguese','pt','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
INSERT INTO LANGUAGE VALUES (14,'Japanese','ja','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
INSERT INTO LANGUAGE VALUES (15,'Dutch','nl','$(hour):$(min)','am','pm','$(short_monthname) $(day), $(year)','$(monthname) $(day), $(year)','$(firstname) $(lastname)','$(firstname) $(lastname) $(blank)');
#
# Table structure for table 'OBJECT'
#
CREATE TABLE OBJECT (
Object_Id int(11) DEFAULT '0' NOT NULL,
Title varchar(80),
Employee_Id int(11),
PRIMARY KEY (Object_Id)
);
#
# Dumping data for table 'OBJECT'
#
INSERT INTO OBJECT VALUES (2,'Company Logo',1);
INSERT INTO OBJECT VALUES (3,'Welcome to Your Private Intranet!',1);
INSERT INTO OBJECT VALUES (4,'Add Your Department Heading Here!',1);
INSERT INTO OBJECT VALUES (5,'New Employees',1);
INSERT INTO OBJECT VALUES (6,'Welcome to Marketing!',1);
INSERT INTO OBJECT VALUES (18,'Marketpage',1);
INSERT INTO OBJECT VALUES (17,'ITpage',1);
INSERT INTO OBJECT VALUES (16,'HRpage',1);
INSERT INTO OBJECT VALUES (15,'Office Information',1);
INSERT INTO OBJECT VALUES (13,'Welcome to the Sales Department',1);
INSERT INTO OBJECT VALUES (19,'Salespage',1);
INSERT INTO OBJECT VALUES (21,'Red Line',1);
INSERT INTO OBJECT VALUES (24,'Women',1);
INSERT INTO OBJECT VALUES (25,'office information',1);
INSERT INTO OBJECT VALUES (101,'Intranet Help Center',1);
INSERT INTO OBJECT VALUES (102,'Creating and Editing Documents',1);
INSERT INTO OBJECT VALUES (103,'Uploading Files',1);
INSERT INTO OBJECT VALUES (113,'gloria',1);
INSERT INTO OBJECT VALUES (105,'Search',1);
INSERT INTO OBJECT VALUES (106,'What\'s New',1);
INSERT INTO OBJECT VALUES (107,'The Final Step',1);
INSERT INTO OBJECT VALUES (111,'Organizing Your Contacts',1);
INSERT INTO OBJECT VALUES (110,'Using Your Calendar',1);
INSERT INTO OBJECT VALUES (112,'Setting Your Preferences',1);
#
# Table structure for table 'PRIMARY_KEY'
#
CREATE TABLE PRIMARY_KEY (
Primary_Key_Id int(11) DEFAULT '0' NOT NULL,
Primary_Key_Name varchar(32),
Maximal_Id int(11),
PRIMARY KEY (Primary_Key_Id)
);
#
# Dumping data for table 'PRIMARY_KEY'
#
INSERT INTO PRIMARY_KEY VALUES (1,'OBJECT',113);
INSERT INTO PRIMARY_KEY VALUES (2,'EMPLOYEE',102);
INSERT INTO PRIMARY_KEY VALUES (3,'SESSION',100);
INSERT INTO PRIMARY_KEY VALUES (4,'TEMPLATE_CLASS',100);
INSERT INTO PRIMARY_KEY VALUES (5,'TEMPLATE_STYLE',100);
INSERT INTO PRIMARY_KEY VALUES (6,'USER_GROUP',102);
INSERT INTO PRIMARY_KEY VALUES (7,'USER_GROUP_PERMISSION',100);
INSERT INTO PRIMARY_KEY VALUES (8,'DEPARTMENT',101);
INSERT INTO PRIMARY_KEY VALUES (9,'SESSION_VARIABLE',100);
INSERT INTO PRIMARY_KEY VALUES (11,'LANGUAGE',16);
INSERT INTO PRIMARY_KEY VALUES (12,'CONTACT_MANAGER',1);
INSERT INTO PRIMARY_KEY VALUES (13,'C_M_NOTES',1);
#
# Table structure for table 'SESSION'
#
CREATE TABLE SESSION (
Session_Id int(11) DEFAULT '0' NOT NULL,
Last_Access int(11),
Employee_Id int(11),
PRIMARY KEY (Session_Id)
);
#
# Dumping data for table 'SESSION'
#
#
# Table structure for table 'SESSION_VARIABLE'
#
CREATE TABLE SESSION_VARIABLE (
Session_Id int(11) DEFAULT '0' NOT NULL,
Variable_Name varchar(80) DEFAULT '' NOT NULL,
Variable_Value varchar(80) DEFAULT '' NOT NULL,
PRIMARY KEY (Session_Id,Variable_Name,Variable_Value)
);
#
# Dumping data for table 'SESSION_VARIABLE'
#
#
# Table structure for table 'SYSTEM_OPTION'
#
CREATE TABLE SYSTEM_OPTION (
System_Option_Id int(11) DEFAULT '0' NOT NULL,
Timeout_Period int(11),
Minimal_Password_Length int(11),
Maximal_Upload_Quota int(11),
Is_Registered int(11),
Headline_Object_Id int(11),
Logo_Object_Id int(11),
Quota int(11),
Quota_Used int(11),
Language_Id int(11) DEFAULT '1' NOT NULL,
PRIMARY KEY (System_Option_Id)
);
#
# Dumping data for table 'SYSTEM_OPTION'
#
INSERT INTO SYSTEM_OPTION VALUES (1,5600,4,300000,6,3,0,31457280,126738,1);
#
# Table structure for table 'TEMPLATE_STYLE'
#
CREATE TABLE TEMPLATE_STYLE (
Template_Style_Id int(11) DEFAULT '0' NOT NULL,
Template_Style_Name varchar(32),
PRIMARY KEY (Template_Style_Id)
);
#
# Dumping data for table 'TEMPLATE_STYLE'
#
INSERT INTO TEMPLATE_STYLE VALUES (1,'Default');
INSERT INTO TEMPLATE_STYLE VALUES (2,'Dull');
INSERT INTO TEMPLATE_STYLE VALUES (3,'Stoned');
#
# Table structure for table 'TIME_ZONE'
#
CREATE TABLE TIME_ZONE (
Time_Zone_Id int(11) DEFAULT '0' NOT NULL,
Offset int(11),
Time_Zone_Name varchar(255),
PRIMARY KEY (Time_Zone_Id)
);
#
# Dumping data for table 'TIME_ZONE'
#
INSERT INTO TIME_ZONE VALUES (1,-720,'Eniwetok, Kwajalein');
INSERT INTO TIME_ZONE VALUES (2,-660,'Samoa');
INSERT INTO TIME_ZONE VALUES (3,-600,'Hawaii');
INSERT INTO TIME_ZONE VALUES (4,-540,'Alaska');
INSERT INTO TIME_ZONE VALUES (5,-480,'Pacific Time');
INSERT INTO TIME_ZONE VALUES (6,-420,'Mountain Time');
INSERT INTO TIME_ZONE VALUES (7,-360,'Central Time');
INSERT INTO TIME_ZONE VALUES (8,-300,'Eastern Time');
INSERT INTO TIME_ZONE VALUES (9,-240,'Atlantic Time');
INSERT INTO TIME_ZONE VALUES (10,-210,'Newfoundland');
INSERT INTO TIME_ZONE VALUES (11,-180,'Buenos Aires');
INSERT INTO TIME_ZONE VALUES (12,-120,'Mid-Atlantic');
INSERT INTO TIME_ZONE VALUES (13,-60,'Azores');
INSERT INTO TIME_ZONE VALUES (14,0,'GMT');
INSERT INTO TIME_ZONE VALUES (15,60,'Amsterdam');
INSERT INTO TIME_ZONE VALUES (16,120,'Cairo');
INSERT INTO TIME_ZONE VALUES (17,180,'Moscow');
INSERT INTO TIME_ZONE VALUES (18,210,'Tehran');
INSERT INTO TIME_ZONE VALUES (19,240,'Abu Dhabi');
INSERT INTO TIME_ZONE VALUES (20,270,'Kabul');
INSERT INTO TIME_ZONE VALUES (21,300,'Islamabad');
INSERT INTO TIME_ZONE VALUES (22,330,'New Delhi');
INSERT INTO TIME_ZONE VALUES (23,360,'Almaty');
INSERT INTO TIME_ZONE VALUES (24,420,'Bangkok');
INSERT INTO TIME_ZONE VALUES (25,480,'Hong Kong');
INSERT INTO TIME_ZONE VALUES (26,540,'Tokyo');
INSERT INTO TIME_ZONE VALUES (27,570,'Adelaide');
INSERT INTO TIME_ZONE VALUES (28,600,'Sydney');
INSERT INTO TIME_ZONE VALUES (29,660,'New Caledonia');
INSERT INTO TIME_ZONE VALUES (30,720,'Fiji');
#
# Table structure for table 'USER_GROUP'
#
CREATE TABLE USER_GROUP (
User_Group_Id int(11) DEFAULT '0' NOT NULL,
User_Group_Name varchar(32),
All_Read int(11),
All_Post int(11),
All_Modify int(11),
Dept_Read int(11),
Dept_Post int(11),
Dept_Modify int(11),
Group_Read int(11),
Group_Post int(11),
Group_Modify int(11),
Department_Id int(11),
PRIMARY KEY (User_Group_Id)
);
#
# Dumping data for table 'USER_GROUP'
#
INSERT INTO USER_GROUP VALUES (2,'Compensation',1,0,0,1,0,0,1,1,1,3);
INSERT INTO USER_GROUP VALUES (102,'Images',0,0,0,0,0,0,0,0,0,101);
INSERT INTO USER_GROUP VALUES (101,'Using Your Intranet',0,0,0,0,0,0,0,0,0,101);
#
# Table structure for table 'USER_GROUP_MEMBERSHIP'
#
CREATE TABLE USER_GROUP_MEMBERSHIP (
Employee_Id int(11) DEFAULT '0' NOT NULL,
User_Group_Id int(11) DEFAULT '0' NOT NULL,
Is_Group_Administrator int(11),
PRIMARY KEY (Employee_Id,User_Group_Id)
);
#
# Dumping data for table 'USER_GROUP_MEMBERSHIP'
#